Aggregation Wizard: Transaction Selection

If you don't have a RFV Value selection then you need to specify a grouping and transaction table.  The transaction table is the first one to be specified and is done so by specifying the group of transaction records to include.

For example, a grouping table could be People and a transaction table could be Bookings.  Assuming that the settings elsewhere in the wizard are set to calculate the sum of Booking Cost, the variable created for each Person by the wizard will be the sum of the cost of all the Bookings taken by that person.

If, however, you want to find the sum of the cost of all flight-only Bookings, drop a selection of Bookings that are flight-only here.

 

Click Next to go to Grouping Table

Click to return to Start